package com.kb.erp.mapper.sqlServer.flow;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kb.erp.entity.flow.ValueStrs;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ValueStrsMapper extends BaseMapper<ValueStrs> {

    @Select("SELECT TOP 1 * FROM [dbo].[valueStrs] WHERE FormDetailId = #{id} AND itemKey = #{itemKey}")
    public ValueStrs queryValue(String id,String itemKey);

    @Select("SELECT * FROM [dbo].[valueStrs]where FormDetailId = #{id}")
    public List<ValueStrs> queryValueById(String id);
}
